| FaCommonLineResponse |
| Logical Entity Name | FaCommonLineResponse |
| Default Table Name | FaCommonLineResponse |
| Physical Only | NO |
| Definition | |
| Note |
| FaCommonLineResponse Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
FaCommonLineResponseID |
int | NO | ||
FaBatchExpImpID |
int | NO | ||
FaLoanID |
int | YES | ||
| CommonlineLoanID | char(17) | NO | ||
| LoanType | char(2) | YES | ||
| CLApplicationStatus | char(1) | YES | ||
| CLApplicationStatusDate | datetime | YES | ||
| CommonLineLoanSeqNum | char(2) | YES | ||
| LoanAmountCertifiedDate | datetime | YES | ||
| LoanAmountGuaranteed | numeric(5, 0) | YES | ||
| LoanGuaranteeDate | datetime | YES | ||
| GuaranteeReductionCode | char(2) | YES | ||
| CLAppLoanPhase | char(4) | YES | ||
| CLAppLoanPhaseDate | datetime | YES | ||
| LoanAmountApproved | numeric(5, 0) | YES | ||
| BorrowerName | char(51) | YES | ||
| BorrowerSSN | char(16) | YES | ||
| RecCode | char(2) | YES | ||
| LoanAmountRequested | numeric(6, 0) | YES | ||
| RejectReason | varchar(160) | YES | ||
| ErrorMsg | varchar(150) | YES | ||
| DateAdded | datetime | NO | ||
| DateLstMod | datetime | NO | ||
| ts | timestamp | NO | ||
UserID |
int | NO | ||
| Status | char(4) | YES | ||
| ValueChangeLog | xml | YES |
| FaCommonLineResponse Primary and Unique Keys |
| Key Name | Key Type | Keys |
| PK_FaCommonLineResponse_FaCommonLineResponseID | PrimaryKey | FaCommonLineResponseID |
| FaCommonLineResponse Foreign Keys |
| Parent Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication |
| FaBatchExpImp | Non-Identifying | One To Zero or More | FK_FaCommonLineResponse_FaBatchExpImpID_FaBatchExpImp_FaBatchExpImpID | FaBatchExpImpID | NO | YES | ||
| FaLoan | Non-Identifying | Zero or One to Zero or More | FK_FaCommonLineResponse_FaLoanID_FaLoan_faloanid | FaLoanID | NO | YES | ||
| SyStaff | Non-Identifying | One To Zero or More | FK_FaCommonLineResponse_UserID_SyStaff_SyStaffID | UserID | NO | YES |
| Child Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication |
| FaCommonLineResponse Check Constraints |
| Check Constraint Name | CheckConstraint |